package com.yule.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class TgctSaleStationExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TgctSaleStationExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andDealeridIsNull() {
            addCriterion("DEALERID_ is null");
            return (Criteria) this;
        }

        public Criteria andDealeridIsNotNull() {
            addCriterion("DEALERID_ is not null");
            return (Criteria) this;
        }

        public Criteria andDealeridEqualTo(String value) {
            addCriterion("DEALERID_ =", value, "dealerid");
            return (Criteria) this;
        }

        public Criteria andDealeridNotEqualTo(String value) {
            addCriterion("DEALERID_ <>", value, "dealerid");
            return (Criteria) this;
        }

        public Criteria andDealeridGreaterThan(String value) {
            addCriterion("DEALERID_ >", value, "dealerid");
            return (Criteria) this;
        }

        public Criteria andDealeridGreaterThanOrEqualTo(String value) {
            addCriterion("DEALERID_ >=", value, "dealerid");
            return (Criteria) this;
        }

        public Criteria andDealeridLessThan(String value) {
            addCriterion("DEALERID_ <", value, "dealerid");
            return (Criteria) this;
        }

        public Criteria andDealeridLessThanOrEqualTo(String value) {
            addCriterion("DEALERID_ <=", value, "dealerid");
            return (Criteria) this;
        }

        public Criteria andDealeridLike(String value) {
            addCriterion("DEALERID_ like", value, "dealerid");
            return (Criteria) this;
        }

        public Criteria andDealeridNotLike(String value) {
            addCriterion("DEALERID_ not like", value, "dealerid");
            return (Criteria) this;
        }

        public Criteria andDealeridIn(List<String> values) {
            addCriterion("DEALERID_ in", values, "dealerid");
            return (Criteria) this;
        }

        public Criteria andDealeridNotIn(List<String> values) {
            addCriterion("DEALERID_ not in", values, "dealerid");
            return (Criteria) this;
        }

        public Criteria andDealeridBetween(String value1, String value2) {
            addCriterion("DEALERID_ between", value1, value2, "dealerid");
            return (Criteria) this;
        }

        public Criteria andDealeridNotBetween(String value1, String value2) {
            addCriterion("DEALERID_ not between", value1, value2, "dealerid");
            return (Criteria) this;
        }

        public Criteria andDealernameIsNull() {
            addCriterion("DEALERNAME_ is null");
            return (Criteria) this;
        }

        public Criteria andDealernameIsNotNull() {
            addCriterion("DEALERNAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andDealernameEqualTo(String value) {
            addCriterion("DEALERNAME_ =", value, "dealername");
            return (Criteria) this;
        }

        public Criteria andDealernameNotEqualTo(String value) {
            addCriterion("DEALERNAME_ <>", value, "dealername");
            return (Criteria) this;
        }

        public Criteria andDealernameGreaterThan(String value) {
            addCriterion("DEALERNAME_ >", value, "dealername");
            return (Criteria) this;
        }

        public Criteria andDealernameGreaterThanOrEqualTo(String value) {
            addCriterion("DEALERNAME_ >=", value, "dealername");
            return (Criteria) this;
        }

        public Criteria andDealernameLessThan(String value) {
            addCriterion("DEALERNAME_ <", value, "dealername");
            return (Criteria) this;
        }

        public Criteria andDealernameLessThanOrEqualTo(String value) {
            addCriterion("DEALERNAME_ <=", value, "dealername");
            return (Criteria) this;
        }

        public Criteria andDealernameLike(String value) {
            addCriterion("DEALERNAME_ like", value, "dealername");
            return (Criteria) this;
        }

        public Criteria andDealernameNotLike(String value) {
            addCriterion("DEALERNAME_ not like", value, "dealername");
            return (Criteria) this;
        }

        public Criteria andDealernameIn(List<String> values) {
            addCriterion("DEALERNAME_ in", values, "dealername");
            return (Criteria) this;
        }

        public Criteria andDealernameNotIn(List<String> values) {
            addCriterion("DEALERNAME_ not in", values, "dealername");
            return (Criteria) this;
        }

        public Criteria andDealernameBetween(String value1, String value2) {
            addCriterion("DEALERNAME_ between", value1, value2, "dealername");
            return (Criteria) this;
        }

        public Criteria andDealernameNotBetween(String value1, String value2) {
            addCriterion("DEALERNAME_ not between", value1, value2, "dealername");
            return (Criteria) this;
        }

        public Criteria andPymIsNull() {
            addCriterion("PYM_ is null");
            return (Criteria) this;
        }

        public Criteria andPymIsNotNull() {
            addCriterion("PYM_ is not null");
            return (Criteria) this;
        }

        public Criteria andPymEqualTo(String value) {
            addCriterion("PYM_ =", value, "pym");
            return (Criteria) this;
        }

        public Criteria andPymNotEqualTo(String value) {
            addCriterion("PYM_ <>", value, "pym");
            return (Criteria) this;
        }

        public Criteria andPymGreaterThan(String value) {
            addCriterion("PYM_ >", value, "pym");
            return (Criteria) this;
        }

        public Criteria andPymGreaterThanOrEqualTo(String value) {
            addCriterion("PYM_ >=", value, "pym");
            return (Criteria) this;
        }

        public Criteria andPymLessThan(String value) {
            addCriterion("PYM_ <", value, "pym");
            return (Criteria) this;
        }

        public Criteria andPymLessThanOrEqualTo(String value) {
            addCriterion("PYM_ <=", value, "pym");
            return (Criteria) this;
        }

        public Criteria andPymLike(String value) {
            addCriterion("PYM_ like", value, "pym");
            return (Criteria) this;
        }

        public Criteria andPymNotLike(String value) {
            addCriterion("PYM_ not like", value, "pym");
            return (Criteria) this;
        }

        public Criteria andPymIn(List<String> values) {
            addCriterion("PYM_ in", values, "pym");
            return (Criteria) this;
        }

        public Criteria andPymNotIn(List<String> values) {
            addCriterion("PYM_ not in", values, "pym");
            return (Criteria) this;
        }

        public Criteria andPymBetween(String value1, String value2) {
            addCriterion("PYM_ between", value1, value2, "pym");
            return (Criteria) this;
        }

        public Criteria andPymNotBetween(String value1, String value2) {
            addCriterion("PYM_ not between", value1, value2, "pym");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidIsNull() {
            addCriterion("DEALERCOMPANYID_ is null");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidIsNotNull() {
            addCriterion("DEALERCOMPANYID_ is not null");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidEqualTo(String value) {
            addCriterion("DEALERCOMPANYID_ =", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidNotEqualTo(String value) {
            addCriterion("DEALERCOMPANYID_ <>", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidGreaterThan(String value) {
            addCriterion("DEALERCOMPANYID_ >", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidGreaterThanOrEqualTo(String value) {
            addCriterion("DEALERCOMPANYID_ >=", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidLessThan(String value) {
            addCriterion("DEALERCOMPANYID_ <", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidLessThanOrEqualTo(String value) {
            addCriterion("DEALERCOMPANYID_ <=", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidLike(String value) {
            addCriterion("DEALERCOMPANYID_ like", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidNotLike(String value) {
            addCriterion("DEALERCOMPANYID_ not like", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidIn(List<String> values) {
            addCriterion("DEALERCOMPANYID_ in", values, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidNotIn(List<String> values) {
            addCriterion("DEALERCOMPANYID_ not in", values, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidBetween(String value1, String value2) {
            addCriterion("DEALERCOMPANYID_ between", value1, value2, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidNotBetween(String value1, String value2) {
            addCriterion("DEALERCOMPANYID_ not between", value1, value2, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidIsNull() {
            addCriterion("COMPANYID_ is null");
            return (Criteria) this;
        }

        public Criteria andCompanyidIsNotNull() {
            addCriterion("COMPANYID_ is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyidEqualTo(String value) {
            addCriterion("COMPANYID_ =", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidNotEqualTo(String value) {
            addCriterion("COMPANYID_ <>", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidGreaterThan(String value) {
            addCriterion("COMPANYID_ >", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidGreaterThanOrEqualTo(String value) {
            addCriterion("COMPANYID_ >=", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidLessThan(String value) {
            addCriterion("COMPANYID_ <", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidLessThanOrEqualTo(String value) {
            addCriterion("COMPANYID_ <=", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidLike(String value) {
            addCriterion("COMPANYID_ like", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidNotLike(String value) {
            addCriterion("COMPANYID_ not like", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidIn(List<String> values) {
            addCriterion("COMPANYID_ in", values, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidNotIn(List<String> values) {
            addCriterion("COMPANYID_ not in", values, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidBetween(String value1, String value2) {
            addCriterion("COMPANYID_ between", value1, value2, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidNotBetween(String value1, String value2) {
            addCriterion("COMPANYID_ not between", value1, value2, "companyid");
            return (Criteria) this;
        }

        public Criteria andBriefIsNull() {
            addCriterion("BRIEF_ is null");
            return (Criteria) this;
        }

        public Criteria andBriefIsNotNull() {
            addCriterion("BRIEF_ is not null");
            return (Criteria) this;
        }

        public Criteria andBriefEqualTo(String value) {
            addCriterion("BRIEF_ =", value, "brief");
            return (Criteria) this;
        }

        public Criteria andBriefNotEqualTo(String value) {
            addCriterion("BRIEF_ <>", value, "brief");
            return (Criteria) this;
        }

        public Criteria andBriefGreaterThan(String value) {
            addCriterion("BRIEF_ >", value, "brief");
            return (Criteria) this;
        }

        public Criteria andBriefGreaterThanOrEqualTo(String value) {
            addCriterion("BRIEF_ >=", value, "brief");
            return (Criteria) this;
        }

        public Criteria andBriefLessThan(String value) {
            addCriterion("BRIEF_ <", value, "brief");
            return (Criteria) this;
        }

        public Criteria andBriefLessThanOrEqualTo(String value) {
            addCriterion("BRIEF_ <=", value, "brief");
            return (Criteria) this;
        }

        public Criteria andBriefLike(String value) {
            addCriterion("BRIEF_ like", value, "brief");
            return (Criteria) this;
        }

        public Criteria andBriefNotLike(String value) {
            addCriterion("BRIEF_ not like", value, "brief");
            return (Criteria) this;
        }

        public Criteria andBriefIn(List<String> values) {
            addCriterion("BRIEF_ in", values, "brief");
            return (Criteria) this;
        }

        public Criteria andBriefNotIn(List<String> values) {
            addCriterion("BRIEF_ not in", values, "brief");
            return (Criteria) this;
        }

        public Criteria andBriefBetween(String value1, String value2) {
            addCriterion("BRIEF_ between", value1, value2, "brief");
            return (Criteria) this;
        }

        public Criteria andBriefNotBetween(String value1, String value2) {
            addCriterion("BRIEF_ not between", value1, value2, "brief");
            return (Criteria) this;
        }

        public Criteria andServicecontextIsNull() {
            addCriterion("SERVICECONTEXT_ is null");
            return (Criteria) this;
        }

        public Criteria andServicecontextIsNotNull() {
            addCriterion("SERVICECONTEXT_ is not null");
            return (Criteria) this;
        }

        public Criteria andServicecontextEqualTo(String value) {
            addCriterion("SERVICECONTEXT_ =", value, "servicecontext");
            return (Criteria) this;
        }

        public Criteria andServicecontextNotEqualTo(String value) {
            addCriterion("SERVICECONTEXT_ <>", value, "servicecontext");
            return (Criteria) this;
        }

        public Criteria andServicecontextGreaterThan(String value) {
            addCriterion("SERVICECONTEXT_ >", value, "servicecontext");
            return (Criteria) this;
        }

        public Criteria andServicecontextGreaterThanOrEqualTo(String value) {
            addCriterion("SERVICECONTEXT_ >=", value, "servicecontext");
            return (Criteria) this;
        }

        public Criteria andServicecontextLessThan(String value) {
            addCriterion("SERVICECONTEXT_ <", value, "servicecontext");
            return (Criteria) this;
        }

        public Criteria andServicecontextLessThanOrEqualTo(String value) {
            addCriterion("SERVICECONTEXT_ <=", value, "servicecontext");
            return (Criteria) this;
        }

        public Criteria andServicecontextLike(String value) {
            addCriterion("SERVICECONTEXT_ like", value, "servicecontext");
            return (Criteria) this;
        }

        public Criteria andServicecontextNotLike(String value) {
            addCriterion("SERVICECONTEXT_ not like", value, "servicecontext");
            return (Criteria) this;
        }

        public Criteria andServicecontextIn(List<String> values) {
            addCriterion("SERVICECONTEXT_ in", values, "servicecontext");
            return (Criteria) this;
        }

        public Criteria andServicecontextNotIn(List<String> values) {
            addCriterion("SERVICECONTEXT_ not in", values, "servicecontext");
            return (Criteria) this;
        }

        public Criteria andServicecontextBetween(String value1, String value2) {
            addCriterion("SERVICECONTEXT_ between", value1, value2, "servicecontext");
            return (Criteria) this;
        }

        public Criteria andServicecontextNotBetween(String value1, String value2) {
            addCriterion("SERVICECONTEXT_ not between", value1, value2, "servicecontext");
            return (Criteria) this;
        }

        public Criteria andDealertypeIsNull() {
            addCriterion("DEALERTYPE_ is null");
            return (Criteria) this;
        }

        public Criteria andDealertypeIsNotNull() {
            addCriterion("DEALERTYPE_ is not null");
            return (Criteria) this;
        }

        public Criteria andDealertypeEqualTo(String value) {
            addCriterion("DEALERTYPE_ =", value, "dealertype");
            return (Criteria) this;
        }

        public Criteria andDealertypeNotEqualTo(String value) {
            addCriterion("DEALERTYPE_ <>", value, "dealertype");
            return (Criteria) this;
        }

        public Criteria andDealertypeGreaterThan(String value) {
            addCriterion("DEALERTYPE_ >", value, "dealertype");
            return (Criteria) this;
        }

        public Criteria andDealertypeGreaterThanOrEqualTo(String value) {
            addCriterion("DEALERTYPE_ >=", value, "dealertype");
            return (Criteria) this;
        }

        public Criteria andDealertypeLessThan(String value) {
            addCriterion("DEALERTYPE_ <", value, "dealertype");
            return (Criteria) this;
        }

        public Criteria andDealertypeLessThanOrEqualTo(String value) {
            addCriterion("DEALERTYPE_ <=", value, "dealertype");
            return (Criteria) this;
        }

        public Criteria andDealertypeLike(String value) {
            addCriterion("DEALERTYPE_ like", value, "dealertype");
            return (Criteria) this;
        }

        public Criteria andDealertypeNotLike(String value) {
            addCriterion("DEALERTYPE_ not like", value, "dealertype");
            return (Criteria) this;
        }

        public Criteria andDealertypeIn(List<String> values) {
            addCriterion("DEALERTYPE_ in", values, "dealertype");
            return (Criteria) this;
        }

        public Criteria andDealertypeNotIn(List<String> values) {
            addCriterion("DEALERTYPE_ not in", values, "dealertype");
            return (Criteria) this;
        }

        public Criteria andDealertypeBetween(String value1, String value2) {
            addCriterion("DEALERTYPE_ between", value1, value2, "dealertype");
            return (Criteria) this;
        }

        public Criteria andDealertypeNotBetween(String value1, String value2) {
            addCriterion("DEALERTYPE_ not between", value1, value2, "dealertype");
            return (Criteria) this;
        }

        public Criteria andDealerlevelIsNull() {
            addCriterion("DEALERLEVEL_ is null");
            return (Criteria) this;
        }

        public Criteria andDealerlevelIsNotNull() {
            addCriterion("DEALERLEVEL_ is not null");
            return (Criteria) this;
        }

        public Criteria andDealerlevelEqualTo(String value) {
            addCriterion("DEALERLEVEL_ =", value, "dealerlevel");
            return (Criteria) this;
        }

        public Criteria andDealerlevelNotEqualTo(String value) {
            addCriterion("DEALERLEVEL_ <>", value, "dealerlevel");
            return (Criteria) this;
        }

        public Criteria andDealerlevelGreaterThan(String value) {
            addCriterion("DEALERLEVEL_ >", value, "dealerlevel");
            return (Criteria) this;
        }

        public Criteria andDealerlevelGreaterThanOrEqualTo(String value) {
            addCriterion("DEALERLEVEL_ >=", value, "dealerlevel");
            return (Criteria) this;
        }

        public Criteria andDealerlevelLessThan(String value) {
            addCriterion("DEALERLEVEL_ <", value, "dealerlevel");
            return (Criteria) this;
        }

        public Criteria andDealerlevelLessThanOrEqualTo(String value) {
            addCriterion("DEALERLEVEL_ <=", value, "dealerlevel");
            return (Criteria) this;
        }

        public Criteria andDealerlevelLike(String value) {
            addCriterion("DEALERLEVEL_ like", value, "dealerlevel");
            return (Criteria) this;
        }

        public Criteria andDealerlevelNotLike(String value) {
            addCriterion("DEALERLEVEL_ not like", value, "dealerlevel");
            return (Criteria) this;
        }

        public Criteria andDealerlevelIn(List<String> values) {
            addCriterion("DEALERLEVEL_ in", values, "dealerlevel");
            return (Criteria) this;
        }

        public Criteria andDealerlevelNotIn(List<String> values) {
            addCriterion("DEALERLEVEL_ not in", values, "dealerlevel");
            return (Criteria) this;
        }

        public Criteria andDealerlevelBetween(String value1, String value2) {
            addCriterion("DEALERLEVEL_ between", value1, value2, "dealerlevel");
            return (Criteria) this;
        }

        public Criteria andDealerlevelNotBetween(String value1, String value2) {
            addCriterion("DEALERLEVEL_ not between", value1, value2, "dealerlevel");
            return (Criteria) this;
        }

        public Criteria andRouteIsNull() {
            addCriterion("ROUTE_ is null");
            return (Criteria) this;
        }

        public Criteria andRouteIsNotNull() {
            addCriterion("ROUTE_ is not null");
            return (Criteria) this;
        }

        public Criteria andRouteEqualTo(String value) {
            addCriterion("ROUTE_ =", value, "route");
            return (Criteria) this;
        }

        public Criteria andRouteNotEqualTo(String value) {
            addCriterion("ROUTE_ <>", value, "route");
            return (Criteria) this;
        }

        public Criteria andRouteGreaterThan(String value) {
            addCriterion("ROUTE_ >", value, "route");
            return (Criteria) this;
        }

        public Criteria andRouteGreaterThanOrEqualTo(String value) {
            addCriterion("ROUTE_ >=", value, "route");
            return (Criteria) this;
        }

        public Criteria andRouteLessThan(String value) {
            addCriterion("ROUTE_ <", value, "route");
            return (Criteria) this;
        }

        public Criteria andRouteLessThanOrEqualTo(String value) {
            addCriterion("ROUTE_ <=", value, "route");
            return (Criteria) this;
        }

        public Criteria andRouteLike(String value) {
            addCriterion("ROUTE_ like", value, "route");
            return (Criteria) this;
        }

        public Criteria andRouteNotLike(String value) {
            addCriterion("ROUTE_ not like", value, "route");
            return (Criteria) this;
        }

        public Criteria andRouteIn(List<String> values) {
            addCriterion("ROUTE_ in", values, "route");
            return (Criteria) this;
        }

        public Criteria andRouteNotIn(List<String> values) {
            addCriterion("ROUTE_ not in", values, "route");
            return (Criteria) this;
        }

        public Criteria andRouteBetween(String value1, String value2) {
            addCriterion("ROUTE_ between", value1, value2, "route");
            return (Criteria) this;
        }

        public Criteria andRouteNotBetween(String value1, String value2) {
            addCriterion("ROUTE_ not between", value1, value2, "route");
            return (Criteria) this;
        }

        public Criteria andTouchpersonIsNull() {
            addCriterion("TOUCHPERSON_ is null");
            return (Criteria) this;
        }

        public Criteria andTouchpersonIsNotNull() {
            addCriterion("TOUCHPERSON_ is not null");
            return (Criteria) this;
        }

        public Criteria andTouchpersonEqualTo(String value) {
            addCriterion("TOUCHPERSON_ =", value, "touchperson");
            return (Criteria) this;
        }

        public Criteria andTouchpersonNotEqualTo(String value) {
            addCriterion("TOUCHPERSON_ <>", value, "touchperson");
            return (Criteria) this;
        }

        public Criteria andTouchpersonGreaterThan(String value) {
            addCriterion("TOUCHPERSON_ >", value, "touchperson");
            return (Criteria) this;
        }

        public Criteria andTouchpersonGreaterThanOrEqualTo(String value) {
            addCriterion("TOUCHPERSON_ >=", value, "touchperson");
            return (Criteria) this;
        }

        public Criteria andTouchpersonLessThan(String value) {
            addCriterion("TOUCHPERSON_ <", value, "touchperson");
            return (Criteria) this;
        }

        public Criteria andTouchpersonLessThanOrEqualTo(String value) {
            addCriterion("TOUCHPERSON_ <=", value, "touchperson");
            return (Criteria) this;
        }

        public Criteria andTouchpersonLike(String value) {
            addCriterion("TOUCHPERSON_ like", value, "touchperson");
            return (Criteria) this;
        }

        public Criteria andTouchpersonNotLike(String value) {
            addCriterion("TOUCHPERSON_ not like", value, "touchperson");
            return (Criteria) this;
        }

        public Criteria andTouchpersonIn(List<String> values) {
            addCriterion("TOUCHPERSON_ in", values, "touchperson");
            return (Criteria) this;
        }

        public Criteria andTouchpersonNotIn(List<String> values) {
            addCriterion("TOUCHPERSON_ not in", values, "touchperson");
            return (Criteria) this;
        }

        public Criteria andTouchpersonBetween(String value1, String value2) {
            addCriterion("TOUCHPERSON_ between", value1, value2, "touchperson");
            return (Criteria) this;
        }

        public Criteria andTouchpersonNotBetween(String value1, String value2) {
            addCriterion("TOUCHPERSON_ not between", value1, value2, "touchperson");
            return (Criteria) this;
        }

        public Criteria andNoteIsNull() {
            addCriterion("NOTE_ is null");
            return (Criteria) this;
        }

        public Criteria andNoteIsNotNull() {
            addCriterion("NOTE_ is not null");
            return (Criteria) this;
        }

        public Criteria andNoteEqualTo(String value) {
            addCriterion("NOTE_ =", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotEqualTo(String value) {
            addCriterion("NOTE_ <>", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThan(String value) {
            addCriterion("NOTE_ >", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThanOrEqualTo(String value) {
            addCriterion("NOTE_ >=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThan(String value) {
            addCriterion("NOTE_ <", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThanOrEqualTo(String value) {
            addCriterion("NOTE_ <=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLike(String value) {
            addCriterion("NOTE_ like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotLike(String value) {
            addCriterion("NOTE_ not like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteIn(List<String> values) {
            addCriterion("NOTE_ in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotIn(List<String> values) {
            addCriterion("NOTE_ not in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteBetween(String value1, String value2) {
            addCriterion("NOTE_ between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotBetween(String value1, String value2) {
            addCriterion("NOTE_ not between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("PROVINCE_ is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("PROVINCE_ is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("PROVINCE_ =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("PROVINCE_ <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("PROVINCE_ >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("PROVINCE_ >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("PROVINCE_ <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("PROVINCE_ <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("PROVINCE_ like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("PROVINCE_ not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("PROVINCE_ in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("PROVINCE_ not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("PROVINCE_ between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("PROVINCE_ not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("CITY_ is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("CITY_ is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("CITY_ =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("CITY_ <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("CITY_ >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("CITY_ >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("CITY_ <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("CITY_ <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("CITY_ like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("CITY_ not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("CITY_ in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("CITY_ not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("CITY_ between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("CITY_ not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andRegionIsNull() {
            addCriterion("REGION_ is null");
            return (Criteria) this;
        }

        public Criteria andRegionIsNotNull() {
            addCriterion("REGION_ is not null");
            return (Criteria) this;
        }

        public Criteria andRegionEqualTo(String value) {
            addCriterion("REGION_ =", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionNotEqualTo(String value) {
            addCriterion("REGION_ <>", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionGreaterThan(String value) {
            addCriterion("REGION_ >", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionGreaterThanOrEqualTo(String value) {
            addCriterion("REGION_ >=", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionLessThan(String value) {
            addCriterion("REGION_ <", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionLessThanOrEqualTo(String value) {
            addCriterion("REGION_ <=", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionLike(String value) {
            addCriterion("REGION_ like", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionNotLike(String value) {
            addCriterion("REGION_ not like", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionIn(List<String> values) {
            addCriterion("REGION_ in", values, "region");
            return (Criteria) this;
        }

        public Criteria andRegionNotIn(List<String> values) {
            addCriterion("REGION_ not in", values, "region");
            return (Criteria) this;
        }

        public Criteria andRegionBetween(String value1, String value2) {
            addCriterion("REGION_ between", value1, value2, "region");
            return (Criteria) this;
        }

        public Criteria andRegionNotBetween(String value1, String value2) {
            addCriterion("REGION_ not between", value1, value2, "region");
            return (Criteria) this;
        }

        public Criteria andProvincecodeIsNull() {
            addCriterion("PROVINCECODE_ is null");
            return (Criteria) this;
        }

        public Criteria andProvincecodeIsNotNull() {
            addCriterion("PROVINCECODE_ is not null");
            return (Criteria) this;
        }

        public Criteria andProvincecodeEqualTo(String value) {
            addCriterion("PROVINCECODE_ =", value, "provincecode");
            return (Criteria) this;
        }

        public Criteria andProvincecodeNotEqualTo(String value) {
            addCriterion("PROVINCECODE_ <>", value, "provincecode");
            return (Criteria) this;
        }

        public Criteria andProvincecodeGreaterThan(String value) {
            addCriterion("PROVINCECODE_ >", value, "provincecode");
            return (Criteria) this;
        }

        public Criteria andProvincecodeGreaterThanOrEqualTo(String value) {
            addCriterion("PROVINCECODE_ >=", value, "provincecode");
            return (Criteria) this;
        }

        public Criteria andProvincecodeLessThan(String value) {
            addCriterion("PROVINCECODE_ <", value, "provincecode");
            return (Criteria) this;
        }

        public Criteria andProvincecodeLessThanOrEqualTo(String value) {
            addCriterion("PROVINCECODE_ <=", value, "provincecode");
            return (Criteria) this;
        }

        public Criteria andProvincecodeLike(String value) {
            addCriterion("PROVINCECODE_ like", value, "provincecode");
            return (Criteria) this;
        }

        public Criteria andProvincecodeNotLike(String value) {
            addCriterion("PROVINCECODE_ not like", value, "provincecode");
            return (Criteria) this;
        }

        public Criteria andProvincecodeIn(List<String> values) {
            addCriterion("PROVINCECODE_ in", values, "provincecode");
            return (Criteria) this;
        }

        public Criteria andProvincecodeNotIn(List<String> values) {
            addCriterion("PROVINCECODE_ not in", values, "provincecode");
            return (Criteria) this;
        }

        public Criteria andProvincecodeBetween(String value1, String value2) {
            addCriterion("PROVINCECODE_ between", value1, value2, "provincecode");
            return (Criteria) this;
        }

        public Criteria andProvincecodeNotBetween(String value1, String value2) {
            addCriterion("PROVINCECODE_ not between", value1, value2, "provincecode");
            return (Criteria) this;
        }

        public Criteria andCitycodeIsNull() {
            addCriterion("CITYCODE_ is null");
            return (Criteria) this;
        }

        public Criteria andCitycodeIsNotNull() {
            addCriterion("CITYCODE_ is not null");
            return (Criteria) this;
        }

        public Criteria andCitycodeEqualTo(String value) {
            addCriterion("CITYCODE_ =", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeNotEqualTo(String value) {
            addCriterion("CITYCODE_ <>", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeGreaterThan(String value) {
            addCriterion("CITYCODE_ >", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeGreaterThanOrEqualTo(String value) {
            addCriterion("CITYCODE_ >=", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeLessThan(String value) {
            addCriterion("CITYCODE_ <", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeLessThanOrEqualTo(String value) {
            addCriterion("CITYCODE_ <=", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeLike(String value) {
            addCriterion("CITYCODE_ like", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeNotLike(String value) {
            addCriterion("CITYCODE_ not like", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeIn(List<String> values) {
            addCriterion("CITYCODE_ in", values, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeNotIn(List<String> values) {
            addCriterion("CITYCODE_ not in", values, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeBetween(String value1, String value2) {
            addCriterion("CITYCODE_ between", value1, value2, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeNotBetween(String value1, String value2) {
            addCriterion("CITYCODE_ not between", value1, value2, "citycode");
            return (Criteria) this;
        }

        public Criteria andRegioncodeIsNull() {
            addCriterion("REGIONCODE_ is null");
            return (Criteria) this;
        }

        public Criteria andRegioncodeIsNotNull() {
            addCriterion("REGIONCODE_ is not null");
            return (Criteria) this;
        }

        public Criteria andRegioncodeEqualTo(String value) {
            addCriterion("REGIONCODE_ =", value, "regioncode");
            return (Criteria) this;
        }

        public Criteria andRegioncodeNotEqualTo(String value) {
            addCriterion("REGIONCODE_ <>", value, "regioncode");
            return (Criteria) this;
        }

        public Criteria andRegioncodeGreaterThan(String value) {
            addCriterion("REGIONCODE_ >", value, "regioncode");
            return (Criteria) this;
        }

        public Criteria andRegioncodeGreaterThanOrEqualTo(String value) {
            addCriterion("REGIONCODE_ >=", value, "regioncode");
            return (Criteria) this;
        }

        public Criteria andRegioncodeLessThan(String value) {
            addCriterion("REGIONCODE_ <", value, "regioncode");
            return (Criteria) this;
        }

        public Criteria andRegioncodeLessThanOrEqualTo(String value) {
            addCriterion("REGIONCODE_ <=", value, "regioncode");
            return (Criteria) this;
        }

        public Criteria andRegioncodeLike(String value) {
            addCriterion("REGIONCODE_ like", value, "regioncode");
            return (Criteria) this;
        }

        public Criteria andRegioncodeNotLike(String value) {
            addCriterion("REGIONCODE_ not like", value, "regioncode");
            return (Criteria) this;
        }

        public Criteria andRegioncodeIn(List<String> values) {
            addCriterion("REGIONCODE_ in", values, "regioncode");
            return (Criteria) this;
        }

        public Criteria andRegioncodeNotIn(List<String> values) {
            addCriterion("REGIONCODE_ not in", values, "regioncode");
            return (Criteria) this;
        }

        public Criteria andRegioncodeBetween(String value1, String value2) {
            addCriterion("REGIONCODE_ between", value1, value2, "regioncode");
            return (Criteria) this;
        }

        public Criteria andRegioncodeNotBetween(String value1, String value2) {
            addCriterion("REGIONCODE_ not between", value1, value2, "regioncode");
            return (Criteria) this;
        }

        public Criteria andTelIsNull() {
            addCriterion("TEL_ is null");
            return (Criteria) this;
        }

        public Criteria andTelIsNotNull() {
            addCriterion("TEL_ is not null");
            return (Criteria) this;
        }

        public Criteria andTelEqualTo(String value) {
            addCriterion("TEL_ =", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotEqualTo(String value) {
            addCriterion("TEL_ <>", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelGreaterThan(String value) {
            addCriterion("TEL_ >", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelGreaterThanOrEqualTo(String value) {
            addCriterion("TEL_ >=", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLessThan(String value) {
            addCriterion("TEL_ <", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLessThanOrEqualTo(String value) {
            addCriterion("TEL_ <=", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLike(String value) {
            addCriterion("TEL_ like", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotLike(String value) {
            addCriterion("TEL_ not like", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelIn(List<String> values) {
            addCriterion("TEL_ in", values, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotIn(List<String> values) {
            addCriterion("TEL_ not in", values, "tel");
            return (Criteria) this;
        }

        public Criteria andTelBetween(String value1, String value2) {
            addCriterion("TEL_ between", value1, value2, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotBetween(String value1, String value2) {
            addCriterion("TEL_ not between", value1, value2, "tel");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("EMAIL_ is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("EMAIL_ is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("EMAIL_ =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("EMAIL_ <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("EMAIL_ >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("EMAIL_ >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("EMAIL_ <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("EMAIL_ <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("EMAIL_ like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("EMAIL_ not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("EMAIL_ in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("EMAIL_ not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("EMAIL_ between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("EMAIL_ not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andQqIsNull() {
            addCriterion("QQ_ is null");
            return (Criteria) this;
        }

        public Criteria andQqIsNotNull() {
            addCriterion("QQ_ is not null");
            return (Criteria) this;
        }

        public Criteria andQqEqualTo(String value) {
            addCriterion("QQ_ =", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotEqualTo(String value) {
            addCriterion("QQ_ <>", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqGreaterThan(String value) {
            addCriterion("QQ_ >", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqGreaterThanOrEqualTo(String value) {
            addCriterion("QQ_ >=", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqLessThan(String value) {
            addCriterion("QQ_ <", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqLessThanOrEqualTo(String value) {
            addCriterion("QQ_ <=", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqLike(String value) {
            addCriterion("QQ_ like", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotLike(String value) {
            addCriterion("QQ_ not like", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqIn(List<String> values) {
            addCriterion("QQ_ in", values, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotIn(List<String> values) {
            addCriterion("QQ_ not in", values, "qq");
            return (Criteria) this;
        }

        public Criteria andQqBetween(String value1, String value2) {
            addCriterion("QQ_ between", value1, value2, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotBetween(String value1, String value2) {
            addCriterion("QQ_ not between", value1, value2, "qq");
            return (Criteria) this;
        }

        public Criteria andMobileIsNull() {
            addCriterion("MOBILE_ is null");
            return (Criteria) this;
        }

        public Criteria andMobileIsNotNull() {
            addCriterion("MOBILE_ is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEqualTo(String value) {
            addCriterion("MOBILE_ =", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotEqualTo(String value) {
            addCriterion("MOBILE_ <>", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThan(String value) {
            addCriterion("MOBILE_ >", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("MOBILE_ >=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThan(String value) {
            addCriterion("MOBILE_ <", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("MOBILE_ <=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLike(String value) {
            addCriterion("MOBILE_ like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotLike(String value) {
            addCriterion("MOBILE_ not like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileIn(List<String> values) {
            addCriterion("MOBILE_ in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotIn(List<String> values) {
            addCriterion("MOBILE_ not in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileBetween(String value1, String value2) {
            addCriterion("MOBILE_ between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotBetween(String value1, String value2) {
            addCriterion("MOBILE_ not between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andFaxIsNull() {
            addCriterion("FAX_ is null");
            return (Criteria) this;
        }

        public Criteria andFaxIsNotNull() {
            addCriterion("FAX_ is not null");
            return (Criteria) this;
        }

        public Criteria andFaxEqualTo(String value) {
            addCriterion("FAX_ =", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotEqualTo(String value) {
            addCriterion("FAX_ <>", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThan(String value) {
            addCriterion("FAX_ >", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThanOrEqualTo(String value) {
            addCriterion("FAX_ >=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThan(String value) {
            addCriterion("FAX_ <", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThanOrEqualTo(String value) {
            addCriterion("FAX_ <=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLike(String value) {
            addCriterion("FAX_ like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotLike(String value) {
            addCriterion("FAX_ not like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxIn(List<String> values) {
            addCriterion("FAX_ in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotIn(List<String> values) {
            addCriterion("FAX_ not in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxBetween(String value1, String value2) {
            addCriterion("FAX_ between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotBetween(String value1, String value2) {
            addCriterion("FAX_ not between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andMainpageIsNull() {
            addCriterion("MAINPAGE_ is null");
            return (Criteria) this;
        }

        public Criteria andMainpageIsNotNull() {
            addCriterion("MAINPAGE_ is not null");
            return (Criteria) this;
        }

        public Criteria andMainpageEqualTo(String value) {
            addCriterion("MAINPAGE_ =", value, "mainpage");
            return (Criteria) this;
        }

        public Criteria andMainpageNotEqualTo(String value) {
            addCriterion("MAINPAGE_ <>", value, "mainpage");
            return (Criteria) this;
        }

        public Criteria andMainpageGreaterThan(String value) {
            addCriterion("MAINPAGE_ >", value, "mainpage");
            return (Criteria) this;
        }

        public Criteria andMainpageGreaterThanOrEqualTo(String value) {
            addCriterion("MAINPAGE_ >=", value, "mainpage");
            return (Criteria) this;
        }

        public Criteria andMainpageLessThan(String value) {
            addCriterion("MAINPAGE_ <", value, "mainpage");
            return (Criteria) this;
        }

        public Criteria andMainpageLessThanOrEqualTo(String value) {
            addCriterion("MAINPAGE_ <=", value, "mainpage");
            return (Criteria) this;
        }

        public Criteria andMainpageLike(String value) {
            addCriterion("MAINPAGE_ like", value, "mainpage");
            return (Criteria) this;
        }

        public Criteria andMainpageNotLike(String value) {
            addCriterion("MAINPAGE_ not like", value, "mainpage");
            return (Criteria) this;
        }

        public Criteria andMainpageIn(List<String> values) {
            addCriterion("MAINPAGE_ in", values, "mainpage");
            return (Criteria) this;
        }

        public Criteria andMainpageNotIn(List<String> values) {
            addCriterion("MAINPAGE_ not in", values, "mainpage");
            return (Criteria) this;
        }

        public Criteria andMainpageBetween(String value1, String value2) {
            addCriterion("MAINPAGE_ between", value1, value2, "mainpage");
            return (Criteria) this;
        }

        public Criteria andMainpageNotBetween(String value1, String value2) {
            addCriterion("MAINPAGE_ not between", value1, value2, "mainpage");
            return (Criteria) this;
        }

        public Criteria andSmallimagepathIsNull() {
            addCriterion("SMALLIMAGEPATH_ is null");
            return (Criteria) this;
        }

        public Criteria andSmallimagepathIsNotNull() {
            addCriterion("SMALLIMAGEPATH_ is not null");
            return (Criteria) this;
        }

        public Criteria andSmallimagepathEqualTo(String value) {
            addCriterion("SMALLIMAGEPATH_ =", value, "smallimagepath");
            return (Criteria) this;
        }

        public Criteria andSmallimagepathNotEqualTo(String value) {
            addCriterion("SMALLIMAGEPATH_ <>", value, "smallimagepath");
            return (Criteria) this;
        }

        public Criteria andSmallimagepathGreaterThan(String value) {
            addCriterion("SMALLIMAGEPATH_ >", value, "smallimagepath");
            return (Criteria) this;
        }

        public Criteria andSmallimagepathGreaterThanOrEqualTo(String value) {
            addCriterion("SMALLIMAGEPATH_ >=", value, "smallimagepath");
            return (Criteria) this;
        }

        public Criteria andSmallimagepathLessThan(String value) {
            addCriterion("SMALLIMAGEPATH_ <", value, "smallimagepath");
            return (Criteria) this;
        }

        public Criteria andSmallimagepathLessThanOrEqualTo(String value) {
            addCriterion("SMALLIMAGEPATH_ <=", value, "smallimagepath");
            return (Criteria) this;
        }

        public Criteria andSmallimagepathLike(String value) {
            addCriterion("SMALLIMAGEPATH_ like", value, "smallimagepath");
            return (Criteria) this;
        }

        public Criteria andSmallimagepathNotLike(String value) {
            addCriterion("SMALLIMAGEPATH_ not like", value, "smallimagepath");
            return (Criteria) this;
        }

        public Criteria andSmallimagepathIn(List<String> values) {
            addCriterion("SMALLIMAGEPATH_ in", values, "smallimagepath");
            return (Criteria) this;
        }

        public Criteria andSmallimagepathNotIn(List<String> values) {
            addCriterion("SMALLIMAGEPATH_ not in", values, "smallimagepath");
            return (Criteria) this;
        }

        public Criteria andSmallimagepathBetween(String value1, String value2) {
            addCriterion("SMALLIMAGEPATH_ between", value1, value2, "smallimagepath");
            return (Criteria) this;
        }

        public Criteria andSmallimagepathNotBetween(String value1, String value2) {
            addCriterion("SMALLIMAGEPATH_ not between", value1, value2, "smallimagepath");
            return (Criteria) this;
        }

        public Criteria andPhoneimagepathIsNull() {
            addCriterion("PHONEIMAGEPATH_ is null");
            return (Criteria) this;
        }

        public Criteria andPhoneimagepathIsNotNull() {
            addCriterion("PHONEIMAGEPATH_ is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneimagepathEqualTo(String value) {
            addCriterion("PHONEIMAGEPATH_ =", value, "phoneimagepath");
            return (Criteria) this;
        }

        public Criteria andPhoneimagepathNotEqualTo(String value) {
            addCriterion("PHONEIMAGEPATH_ <>", value, "phoneimagepath");
            return (Criteria) this;
        }

        public Criteria andPhoneimagepathGreaterThan(String value) {
            addCriterion("PHONEIMAGEPATH_ >", value, "phoneimagepath");
            return (Criteria) this;
        }

        public Criteria andPhoneimagepathGreaterThanOrEqualTo(String value) {
            addCriterion("PHONEIMAGEPATH_ >=", value, "phoneimagepath");
            return (Criteria) this;
        }

        public Criteria andPhoneimagepathLessThan(String value) {
            addCriterion("PHONEIMAGEPATH_ <", value, "phoneimagepath");
            return (Criteria) this;
        }

        public Criteria andPhoneimagepathLessThanOrEqualTo(String value) {
            addCriterion("PHONEIMAGEPATH_ <=", value, "phoneimagepath");
            return (Criteria) this;
        }

        public Criteria andPhoneimagepathLike(String value) {
            addCriterion("PHONEIMAGEPATH_ like", value, "phoneimagepath");
            return (Criteria) this;
        }

        public Criteria andPhoneimagepathNotLike(String value) {
            addCriterion("PHONEIMAGEPATH_ not like", value, "phoneimagepath");
            return (Criteria) this;
        }

        public Criteria andPhoneimagepathIn(List<String> values) {
            addCriterion("PHONEIMAGEPATH_ in", values, "phoneimagepath");
            return (Criteria) this;
        }

        public Criteria andPhoneimagepathNotIn(List<String> values) {
            addCriterion("PHONEIMAGEPATH_ not in", values, "phoneimagepath");
            return (Criteria) this;
        }

        public Criteria andPhoneimagepathBetween(String value1, String value2) {
            addCriterion("PHONEIMAGEPATH_ between", value1, value2, "phoneimagepath");
            return (Criteria) this;
        }

        public Criteria andPhoneimagepathNotBetween(String value1, String value2) {
            addCriterion("PHONEIMAGEPATH_ not between", value1, value2, "phoneimagepath");
            return (Criteria) this;
        }

        public Criteria andMaximagepathIsNull() {
            addCriterion("MAXIMAGEPATH_ is null");
            return (Criteria) this;
        }

        public Criteria andMaximagepathIsNotNull() {
            addCriterion("MAXIMAGEPATH_ is not null");
            return (Criteria) this;
        }

        public Criteria andMaximagepathEqualTo(String value) {
            addCriterion("MAXIMAGEPATH_ =", value, "maximagepath");
            return (Criteria) this;
        }

        public Criteria andMaximagepathNotEqualTo(String value) {
            addCriterion("MAXIMAGEPATH_ <>", value, "maximagepath");
            return (Criteria) this;
        }

        public Criteria andMaximagepathGreaterThan(String value) {
            addCriterion("MAXIMAGEPATH_ >", value, "maximagepath");
            return (Criteria) this;
        }

        public Criteria andMaximagepathGreaterThanOrEqualTo(String value) {
            addCriterion("MAXIMAGEPATH_ >=", value, "maximagepath");
            return (Criteria) this;
        }

        public Criteria andMaximagepathLessThan(String value) {
            addCriterion("MAXIMAGEPATH_ <", value, "maximagepath");
            return (Criteria) this;
        }

        public Criteria andMaximagepathLessThanOrEqualTo(String value) {
            addCriterion("MAXIMAGEPATH_ <=", value, "maximagepath");
            return (Criteria) this;
        }

        public Criteria andMaximagepathLike(String value) {
            addCriterion("MAXIMAGEPATH_ like", value, "maximagepath");
            return (Criteria) this;
        }

        public Criteria andMaximagepathNotLike(String value) {
            addCriterion("MAXIMAGEPATH_ not like", value, "maximagepath");
            return (Criteria) this;
        }

        public Criteria andMaximagepathIn(List<String> values) {
            addCriterion("MAXIMAGEPATH_ in", values, "maximagepath");
            return (Criteria) this;
        }

        public Criteria andMaximagepathNotIn(List<String> values) {
            addCriterion("MAXIMAGEPATH_ not in", values, "maximagepath");
            return (Criteria) this;
        }

        public Criteria andMaximagepathBetween(String value1, String value2) {
            addCriterion("MAXIMAGEPATH_ between", value1, value2, "maximagepath");
            return (Criteria) this;
        }

        public Criteria andMaximagepathNotBetween(String value1, String value2) {
            addCriterion("MAXIMAGEPATH_ not between", value1, value2, "maximagepath");
            return (Criteria) this;
        }

        public Criteria andOrderidIsNull() {
            addCriterion("ORDERID_ is null");
            return (Criteria) this;
        }

        public Criteria andOrderidIsNotNull() {
            addCriterion("ORDERID_ is not null");
            return (Criteria) this;
        }

        public Criteria andOrderidEqualTo(BigDecimal value) {
            addCriterion("ORDERID_ =", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotEqualTo(BigDecimal value) {
            addCriterion("ORDERID_ <>", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidGreaterThan(BigDecimal value) {
            addCriterion("ORDERID_ >", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ORDERID_ >=", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLessThan(BigDecimal value) {
            addCriterion("ORDERID_ <", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ORDERID_ <=", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidIn(List<BigDecimal> values) {
            addCriterion("ORDERID_ in", values, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotIn(List<BigDecimal> values) {
            addCriterion("ORDERID_ not in", values, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ORDERID_ between", value1, value2, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ORDERID_ not between", value1, value2, "orderid");
            return (Criteria) this;
        }

        public Criteria andXIsNull() {
            addCriterion("X_ is null");
            return (Criteria) this;
        }

        public Criteria andXIsNotNull() {
            addCriterion("X_ is not null");
            return (Criteria) this;
        }

        public Criteria andXEqualTo(String value) {
            addCriterion("X_ =", value, "x");
            return (Criteria) this;
        }

        public Criteria andXNotEqualTo(String value) {
            addCriterion("X_ <>", value, "x");
            return (Criteria) this;
        }

        public Criteria andXGreaterThan(String value) {
            addCriterion("X_ >", value, "x");
            return (Criteria) this;
        }

        public Criteria andXGreaterThanOrEqualTo(String value) {
            addCriterion("X_ >=", value, "x");
            return (Criteria) this;
        }

        public Criteria andXLessThan(String value) {
            addCriterion("X_ <", value, "x");
            return (Criteria) this;
        }

        public Criteria andXLessThanOrEqualTo(String value) {
            addCriterion("X_ <=", value, "x");
            return (Criteria) this;
        }

        public Criteria andXLike(String value) {
            addCriterion("X_ like", value, "x");
            return (Criteria) this;
        }

        public Criteria andXNotLike(String value) {
            addCriterion("X_ not like", value, "x");
            return (Criteria) this;
        }

        public Criteria andXIn(List<String> values) {
            addCriterion("X_ in", values, "x");
            return (Criteria) this;
        }

        public Criteria andXNotIn(List<String> values) {
            addCriterion("X_ not in", values, "x");
            return (Criteria) this;
        }

        public Criteria andXBetween(String value1, String value2) {
            addCriterion("X_ between", value1, value2, "x");
            return (Criteria) this;
        }

        public Criteria andXNotBetween(String value1, String value2) {
            addCriterion("X_ not between", value1, value2, "x");
            return (Criteria) this;
        }

        public Criteria andYIsNull() {
            addCriterion("Y_ is null");
            return (Criteria) this;
        }

        public Criteria andYIsNotNull() {
            addCriterion("Y_ is not null");
            return (Criteria) this;
        }

        public Criteria andYEqualTo(String value) {
            addCriterion("Y_ =", value, "y");
            return (Criteria) this;
        }

        public Criteria andYNotEqualTo(String value) {
            addCriterion("Y_ <>", value, "y");
            return (Criteria) this;
        }

        public Criteria andYGreaterThan(String value) {
            addCriterion("Y_ >", value, "y");
            return (Criteria) this;
        }

        public Criteria andYGreaterThanOrEqualTo(String value) {
            addCriterion("Y_ >=", value, "y");
            return (Criteria) this;
        }

        public Criteria andYLessThan(String value) {
            addCriterion("Y_ <", value, "y");
            return (Criteria) this;
        }

        public Criteria andYLessThanOrEqualTo(String value) {
            addCriterion("Y_ <=", value, "y");
            return (Criteria) this;
        }

        public Criteria andYLike(String value) {
            addCriterion("Y_ like", value, "y");
            return (Criteria) this;
        }

        public Criteria andYNotLike(String value) {
            addCriterion("Y_ not like", value, "y");
            return (Criteria) this;
        }

        public Criteria andYIn(List<String> values) {
            addCriterion("Y_ in", values, "y");
            return (Criteria) this;
        }

        public Criteria andYNotIn(List<String> values) {
            addCriterion("Y_ not in", values, "y");
            return (Criteria) this;
        }

        public Criteria andYBetween(String value1, String value2) {
            addCriterion("Y_ between", value1, value2, "y");
            return (Criteria) this;
        }

        public Criteria andYNotBetween(String value1, String value2) {
            addCriterion("Y_ not between", value1, value2, "y");
            return (Criteria) this;
        }

        public Criteria andLongitudeIsNull() {
            addCriterion("LONGITUDE_ is null");
            return (Criteria) this;
        }

        public Criteria andLongitudeIsNotNull() {
            addCriterion("LONGITUDE_ is not null");
            return (Criteria) this;
        }

        public Criteria andLongitudeEqualTo(String value) {
            addCriterion("LONGITUDE_ =", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeNotEqualTo(String value) {
            addCriterion("LONGITUDE_ <>", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeGreaterThan(String value) {
            addCriterion("LONGITUDE_ >", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeGreaterThanOrEqualTo(String value) {
            addCriterion("LONGITUDE_ >=", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeLessThan(String value) {
            addCriterion("LONGITUDE_ <", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeLessThanOrEqualTo(String value) {
            addCriterion("LONGITUDE_ <=", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeLike(String value) {
            addCriterion("LONGITUDE_ like", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeNotLike(String value) {
            addCriterion("LONGITUDE_ not like", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeIn(List<String> values) {
            addCriterion("LONGITUDE_ in", values, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeNotIn(List<String> values) {
            addCriterion("LONGITUDE_ not in", values, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeBetween(String value1, String value2) {
            addCriterion("LONGITUDE_ between", value1, value2, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeNotBetween(String value1, String value2) {
            addCriterion("LONGITUDE_ not between", value1, value2, "longitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeIsNull() {
            addCriterion("LATITUDE_ is null");
            return (Criteria) this;
        }

        public Criteria andLatitudeIsNotNull() {
            addCriterion("LATITUDE_ is not null");
            return (Criteria) this;
        }

        public Criteria andLatitudeEqualTo(String value) {
            addCriterion("LATITUDE_ =", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeNotEqualTo(String value) {
            addCriterion("LATITUDE_ <>", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeGreaterThan(String value) {
            addCriterion("LATITUDE_ >", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeGreaterThanOrEqualTo(String value) {
            addCriterion("LATITUDE_ >=", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeLessThan(String value) {
            addCriterion("LATITUDE_ <", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeLessThanOrEqualTo(String value) {
            addCriterion("LATITUDE_ <=", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeLike(String value) {
            addCriterion("LATITUDE_ like", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeNotLike(String value) {
            addCriterion("LATITUDE_ not like", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeIn(List<String> values) {
            addCriterion("LATITUDE_ in", values, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeNotIn(List<String> values) {
            addCriterion("LATITUDE_ not in", values, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeBetween(String value1, String value2) {
            addCriterion("LATITUDE_ between", value1, value2, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeNotBetween(String value1, String value2) {
            addCriterion("LATITUDE_ not between", value1, value2, "latitude");
            return (Criteria) this;
        }

        public Criteria andAltitudeIsNull() {
            addCriterion("ALTITUDE_ is null");
            return (Criteria) this;
        }

        public Criteria andAltitudeIsNotNull() {
            addCriterion("ALTITUDE_ is not null");
            return (Criteria) this;
        }

        public Criteria andAltitudeEqualTo(String value) {
            addCriterion("ALTITUDE_ =", value, "altitude");
            return (Criteria) this;
        }

        public Criteria andAltitudeNotEqualTo(String value) {
            addCriterion("ALTITUDE_ <>", value, "altitude");
            return (Criteria) this;
        }

        public Criteria andAltitudeGreaterThan(String value) {
            addCriterion("ALTITUDE_ >", value, "altitude");
            return (Criteria) this;
        }

        public Criteria andAltitudeGreaterThanOrEqualTo(String value) {
            addCriterion("ALTITUDE_ >=", value, "altitude");
            return (Criteria) this;
        }

        public Criteria andAltitudeLessThan(String value) {
            addCriterion("ALTITUDE_ <", value, "altitude");
            return (Criteria) this;
        }

        public Criteria andAltitudeLessThanOrEqualTo(String value) {
            addCriterion("ALTITUDE_ <=", value, "altitude");
            return (Criteria) this;
        }

        public Criteria andAltitudeLike(String value) {
            addCriterion("ALTITUDE_ like", value, "altitude");
            return (Criteria) this;
        }

        public Criteria andAltitudeNotLike(String value) {
            addCriterion("ALTITUDE_ not like", value, "altitude");
            return (Criteria) this;
        }

        public Criteria andAltitudeIn(List<String> values) {
            addCriterion("ALTITUDE_ in", values, "altitude");
            return (Criteria) this;
        }

        public Criteria andAltitudeNotIn(List<String> values) {
            addCriterion("ALTITUDE_ not in", values, "altitude");
            return (Criteria) this;
        }

        public Criteria andAltitudeBetween(String value1, String value2) {
            addCriterion("ALTITUDE_ between", value1, value2, "altitude");
            return (Criteria) this;
        }

        public Criteria andAltitudeNotBetween(String value1, String value2) {
            addCriterion("ALTITUDE_ not between", value1, value2, "altitude");
            return (Criteria) this;
        }

        public Criteria andServicbegintimeIsNull() {
            addCriterion("SERVICBEGINTIME_ is null");
            return (Criteria) this;
        }

        public Criteria andServicbegintimeIsNotNull() {
            addCriterion("SERVICBEGINTIME_ is not null");
            return (Criteria) this;
        }

        public Criteria andServicbegintimeEqualTo(BigDecimal value) {
            addCriterion("SERVICBEGINTIME_ =", value, "servicbegintime");
            return (Criteria) this;
        }

        public Criteria andServicbegintimeNotEqualTo(BigDecimal value) {
            addCriterion("SERVICBEGINTIME_ <>", value, "servicbegintime");
            return (Criteria) this;
        }

        public Criteria andServicbegintimeGreaterThan(BigDecimal value) {
            addCriterion("SERVICBEGINTIME_ >", value, "servicbegintime");
            return (Criteria) this;
        }

        public Criteria andServicbegintimeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SERVICBEGINTIME_ >=", value, "servicbegintime");
            return (Criteria) this;
        }

        public Criteria andServicbegintimeLessThan(BigDecimal value) {
            addCriterion("SERVICBEGINTIME_ <", value, "servicbegintime");
            return (Criteria) this;
        }

        public Criteria andServicbegintimeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SERVICBEGINTIME_ <=", value, "servicbegintime");
            return (Criteria) this;
        }

        public Criteria andServicbegintimeIn(List<BigDecimal> values) {
            addCriterion("SERVICBEGINTIME_ in", values, "servicbegintime");
            return (Criteria) this;
        }

        public Criteria andServicbegintimeNotIn(List<BigDecimal> values) {
            addCriterion("SERVICBEGINTIME_ not in", values, "servicbegintime");
            return (Criteria) this;
        }

        public Criteria andServicbegintimeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SERVICBEGINTIME_ between", value1, value2, "servicbegintime");
            return (Criteria) this;
        }

        public Criteria andServicbegintimeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SERVICBEGINTIME_ not between", value1, value2, "servicbegintime");
            return (Criteria) this;
        }

        public Criteria andServicendtimeIsNull() {
            addCriterion("SERVICENDTIME_ is null");
            return (Criteria) this;
        }

        public Criteria andServicendtimeIsNotNull() {
            addCriterion("SERVICENDTIME_ is not null");
            return (Criteria) this;
        }

        public Criteria andServicendtimeEqualTo(BigDecimal value) {
            addCriterion("SERVICENDTIME_ =", value, "servicendtime");
            return (Criteria) this;
        }

        public Criteria andServicendtimeNotEqualTo(BigDecimal value) {
            addCriterion("SERVICENDTIME_ <>", value, "servicendtime");
            return (Criteria) this;
        }

        public Criteria andServicendtimeGreaterThan(BigDecimal value) {
            addCriterion("SERVICENDTIME_ >", value, "servicendtime");
            return (Criteria) this;
        }

        public Criteria andServicendtimeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SERVICENDTIME_ >=", value, "servicendtime");
            return (Criteria) this;
        }

        public Criteria andServicendtimeLessThan(BigDecimal value) {
            addCriterion("SERVICENDTIME_ <", value, "servicendtime");
            return (Criteria) this;
        }

        public Criteria andServicendtimeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SERVICENDTIME_ <=", value, "servicendtime");
            return (Criteria) this;
        }

        public Criteria andServicendtimeIn(List<BigDecimal> values) {
            addCriterion("SERVICENDTIME_ in", values, "servicendtime");
            return (Criteria) this;
        }

        public Criteria andServicendtimeNotIn(List<BigDecimal> values) {
            addCriterion("SERVICENDTIME_ not in", values, "servicendtime");
            return (Criteria) this;
        }

        public Criteria andServicendtimeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SERVICENDTIME_ between", value1, value2, "servicendtime");
            return (Criteria) this;
        }

        public Criteria andServicendtimeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SERVICENDTIME_ not between", value1, value2, "servicendtime");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("STATUS_ is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("STATUS_ is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("STATUS_ =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("STATUS_ <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("STATUS_ >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("STATUS_ >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("STATUS_ <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("STATUS_ <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("STATUS_ like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("STATUS_ not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("STATUS_ in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("STATUS_ not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("STATUS_ between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("STATUS_ not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("UPDATETIME_ is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("UPDATETIME_ is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(BigDecimal value) {
            addCriterion("UPDATETIME_ =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(BigDecimal value) {
            addCriterion("UPDATETIME_ <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(BigDecimal value) {
            addCriterion("UPDATETIME_ >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("UPDATETIME_ >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(BigDecimal value) {
            addCriterion("UPDATETIME_ <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("UPDATETIME_ <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<BigDecimal> values) {
            addCriterion("UPDATETIME_ in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<BigDecimal> values) {
            addCriterion("UPDATETIME_ not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("UPDATETIME_ between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("UPDATETIME_ not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andOperationidIsNull() {
            addCriterion("OPERATIONID_ is null");
            return (Criteria) this;
        }

        public Criteria andOperationidIsNotNull() {
            addCriterion("OPERATIONID_ is not null");
            return (Criteria) this;
        }

        public Criteria andOperationidEqualTo(String value) {
            addCriterion("OPERATIONID_ =", value, "operationid");
            return (Criteria) this;
        }

        public Criteria andOperationidNotEqualTo(String value) {
            addCriterion("OPERATIONID_ <>", value, "operationid");
            return (Criteria) this;
        }

        public Criteria andOperationidGreaterThan(String value) {
            addCriterion("OPERATIONID_ >", value, "operationid");
            return (Criteria) this;
        }

        public Criteria andOperationidGreaterThanOrEqualTo(String value) {
            addCriterion("OPERATIONID_ >=", value, "operationid");
            return (Criteria) this;
        }

        public Criteria andOperationidLessThan(String value) {
            addCriterion("OPERATIONID_ <", value, "operationid");
            return (Criteria) this;
        }

        public Criteria andOperationidLessThanOrEqualTo(String value) {
            addCriterion("OPERATIONID_ <=", value, "operationid");
            return (Criteria) this;
        }

        public Criteria andOperationidLike(String value) {
            addCriterion("OPERATIONID_ like", value, "operationid");
            return (Criteria) this;
        }

        public Criteria andOperationidNotLike(String value) {
            addCriterion("OPERATIONID_ not like", value, "operationid");
            return (Criteria) this;
        }

        public Criteria andOperationidIn(List<String> values) {
            addCriterion("OPERATIONID_ in", values, "operationid");
            return (Criteria) this;
        }

        public Criteria andOperationidNotIn(List<String> values) {
            addCriterion("OPERATIONID_ not in", values, "operationid");
            return (Criteria) this;
        }

        public Criteria andOperationidBetween(String value1, String value2) {
            addCriterion("OPERATIONID_ between", value1, value2, "operationid");
            return (Criteria) this;
        }

        public Criteria andOperationidNotBetween(String value1, String value2) {
            addCriterion("OPERATIONID_ not between", value1, value2, "operationid");
            return (Criteria) this;
        }

        public Criteria andAttris1IsNull() {
            addCriterion("ATTRIS1_ is null");
            return (Criteria) this;
        }

        public Criteria andAttris1IsNotNull() {
            addCriterion("ATTRIS1_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttris1EqualTo(String value) {
            addCriterion("ATTRIS1_ =", value, "attris1");
            return (Criteria) this;
        }

        public Criteria andAttris1NotEqualTo(String value) {
            addCriterion("ATTRIS1_ <>", value, "attris1");
            return (Criteria) this;
        }

        public Criteria andAttris1GreaterThan(String value) {
            addCriterion("ATTRIS1_ >", value, "attris1");
            return (Criteria) this;
        }

        public Criteria andAttris1GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRIS1_ >=", value, "attris1");
            return (Criteria) this;
        }

        public Criteria andAttris1LessThan(String value) {
            addCriterion("ATTRIS1_ <", value, "attris1");
            return (Criteria) this;
        }

        public Criteria andAttris1LessThanOrEqualTo(String value) {
            addCriterion("ATTRIS1_ <=", value, "attris1");
            return (Criteria) this;
        }

        public Criteria andAttris1Like(String value) {
            addCriterion("ATTRIS1_ like", value, "attris1");
            return (Criteria) this;
        }

        public Criteria andAttris1NotLike(String value) {
            addCriterion("ATTRIS1_ not like", value, "attris1");
            return (Criteria) this;
        }

        public Criteria andAttris1In(List<String> values) {
            addCriterion("ATTRIS1_ in", values, "attris1");
            return (Criteria) this;
        }

        public Criteria andAttris1NotIn(List<String> values) {
            addCriterion("ATTRIS1_ not in", values, "attris1");
            return (Criteria) this;
        }

        public Criteria andAttris1Between(String value1, String value2) {
            addCriterion("ATTRIS1_ between", value1, value2, "attris1");
            return (Criteria) this;
        }

        public Criteria andAttris1NotBetween(String value1, String value2) {
            addCriterion("ATTRIS1_ not between", value1, value2, "attris1");
            return (Criteria) this;
        }

        public Criteria andAttris2IsNull() {
            addCriterion("ATTRIS2_ is null");
            return (Criteria) this;
        }

        public Criteria andAttris2IsNotNull() {
            addCriterion("ATTRIS2_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttris2EqualTo(String value) {
            addCriterion("ATTRIS2_ =", value, "attris2");
            return (Criteria) this;
        }

        public Criteria andAttris2NotEqualTo(String value) {
            addCriterion("ATTRIS2_ <>", value, "attris2");
            return (Criteria) this;
        }

        public Criteria andAttris2GreaterThan(String value) {
            addCriterion("ATTRIS2_ >", value, "attris2");
            return (Criteria) this;
        }

        public Criteria andAttris2GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRIS2_ >=", value, "attris2");
            return (Criteria) this;
        }

        public Criteria andAttris2LessThan(String value) {
            addCriterion("ATTRIS2_ <", value, "attris2");
            return (Criteria) this;
        }

        public Criteria andAttris2LessThanOrEqualTo(String value) {
            addCriterion("ATTRIS2_ <=", value, "attris2");
            return (Criteria) this;
        }

        public Criteria andAttris2Like(String value) {
            addCriterion("ATTRIS2_ like", value, "attris2");
            return (Criteria) this;
        }

        public Criteria andAttris2NotLike(String value) {
            addCriterion("ATTRIS2_ not like", value, "attris2");
            return (Criteria) this;
        }

        public Criteria andAttris2In(List<String> values) {
            addCriterion("ATTRIS2_ in", values, "attris2");
            return (Criteria) this;
        }

        public Criteria andAttris2NotIn(List<String> values) {
            addCriterion("ATTRIS2_ not in", values, "attris2");
            return (Criteria) this;
        }

        public Criteria andAttris2Between(String value1, String value2) {
            addCriterion("ATTRIS2_ between", value1, value2, "attris2");
            return (Criteria) this;
        }

        public Criteria andAttris2NotBetween(String value1, String value2) {
            addCriterion("ATTRIS2_ not between", value1, value2, "attris2");
            return (Criteria) this;
        }

        public Criteria andAttris3IsNull() {
            addCriterion("ATTRIS3_ is null");
            return (Criteria) this;
        }

        public Criteria andAttris3IsNotNull() {
            addCriterion("ATTRIS3_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttris3EqualTo(String value) {
            addCriterion("ATTRIS3_ =", value, "attris3");
            return (Criteria) this;
        }

        public Criteria andAttris3NotEqualTo(String value) {
            addCriterion("ATTRIS3_ <>", value, "attris3");
            return (Criteria) this;
        }

        public Criteria andAttris3GreaterThan(String value) {
            addCriterion("ATTRIS3_ >", value, "attris3");
            return (Criteria) this;
        }

        public Criteria andAttris3GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRIS3_ >=", value, "attris3");
            return (Criteria) this;
        }

        public Criteria andAttris3LessThan(String value) {
            addCriterion("ATTRIS3_ <", value, "attris3");
            return (Criteria) this;
        }

        public Criteria andAttris3LessThanOrEqualTo(String value) {
            addCriterion("ATTRIS3_ <=", value, "attris3");
            return (Criteria) this;
        }

        public Criteria andAttris3Like(String value) {
            addCriterion("ATTRIS3_ like", value, "attris3");
            return (Criteria) this;
        }

        public Criteria andAttris3NotLike(String value) {
            addCriterion("ATTRIS3_ not like", value, "attris3");
            return (Criteria) this;
        }

        public Criteria andAttris3In(List<String> values) {
            addCriterion("ATTRIS3_ in", values, "attris3");
            return (Criteria) this;
        }

        public Criteria andAttris3NotIn(List<String> values) {
            addCriterion("ATTRIS3_ not in", values, "attris3");
            return (Criteria) this;
        }

        public Criteria andAttris3Between(String value1, String value2) {
            addCriterion("ATTRIS3_ between", value1, value2, "attris3");
            return (Criteria) this;
        }

        public Criteria andAttris3NotBetween(String value1, String value2) {
            addCriterion("ATTRIS3_ not between", value1, value2, "attris3");
            return (Criteria) this;
        }

        public Criteria andAttris4IsNull() {
            addCriterion("ATTRIS4_ is null");
            return (Criteria) this;
        }

        public Criteria andAttris4IsNotNull() {
            addCriterion("ATTRIS4_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttris4EqualTo(String value) {
            addCriterion("ATTRIS4_ =", value, "attris4");
            return (Criteria) this;
        }

        public Criteria andAttris4NotEqualTo(String value) {
            addCriterion("ATTRIS4_ <>", value, "attris4");
            return (Criteria) this;
        }

        public Criteria andAttris4GreaterThan(String value) {
            addCriterion("ATTRIS4_ >", value, "attris4");
            return (Criteria) this;
        }

        public Criteria andAttris4GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRIS4_ >=", value, "attris4");
            return (Criteria) this;
        }

        public Criteria andAttris4LessThan(String value) {
            addCriterion("ATTRIS4_ <", value, "attris4");
            return (Criteria) this;
        }

        public Criteria andAttris4LessThanOrEqualTo(String value) {
            addCriterion("ATTRIS4_ <=", value, "attris4");
            return (Criteria) this;
        }

        public Criteria andAttris4Like(String value) {
            addCriterion("ATTRIS4_ like", value, "attris4");
            return (Criteria) this;
        }

        public Criteria andAttris4NotLike(String value) {
            addCriterion("ATTRIS4_ not like", value, "attris4");
            return (Criteria) this;
        }

        public Criteria andAttris4In(List<String> values) {
            addCriterion("ATTRIS4_ in", values, "attris4");
            return (Criteria) this;
        }

        public Criteria andAttris4NotIn(List<String> values) {
            addCriterion("ATTRIS4_ not in", values, "attris4");
            return (Criteria) this;
        }

        public Criteria andAttris4Between(String value1, String value2) {
            addCriterion("ATTRIS4_ between", value1, value2, "attris4");
            return (Criteria) this;
        }

        public Criteria andAttris4NotBetween(String value1, String value2) {
            addCriterion("ATTRIS4_ not between", value1, value2, "attris4");
            return (Criteria) this;
        }

        public Criteria andAttris5IsNull() {
            addCriterion("ATTRIS5_ is null");
            return (Criteria) this;
        }

        public Criteria andAttris5IsNotNull() {
            addCriterion("ATTRIS5_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttris5EqualTo(String value) {
            addCriterion("ATTRIS5_ =", value, "attris5");
            return (Criteria) this;
        }

        public Criteria andAttris5NotEqualTo(String value) {
            addCriterion("ATTRIS5_ <>", value, "attris5");
            return (Criteria) this;
        }

        public Criteria andAttris5GreaterThan(String value) {
            addCriterion("ATTRIS5_ >", value, "attris5");
            return (Criteria) this;
        }

        public Criteria andAttris5GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRIS5_ >=", value, "attris5");
            return (Criteria) this;
        }

        public Criteria andAttris5LessThan(String value) {
            addCriterion("ATTRIS5_ <", value, "attris5");
            return (Criteria) this;
        }

        public Criteria andAttris5LessThanOrEqualTo(String value) {
            addCriterion("ATTRIS5_ <=", value, "attris5");
            return (Criteria) this;
        }

        public Criteria andAttris5Like(String value) {
            addCriterion("ATTRIS5_ like", value, "attris5");
            return (Criteria) this;
        }

        public Criteria andAttris5NotLike(String value) {
            addCriterion("ATTRIS5_ not like", value, "attris5");
            return (Criteria) this;
        }

        public Criteria andAttris5In(List<String> values) {
            addCriterion("ATTRIS5_ in", values, "attris5");
            return (Criteria) this;
        }

        public Criteria andAttris5NotIn(List<String> values) {
            addCriterion("ATTRIS5_ not in", values, "attris5");
            return (Criteria) this;
        }

        public Criteria andAttris5Between(String value1, String value2) {
            addCriterion("ATTRIS5_ between", value1, value2, "attris5");
            return (Criteria) this;
        }

        public Criteria andAttris5NotBetween(String value1, String value2) {
            addCriterion("ATTRIS5_ not between", value1, value2, "attris5");
            return (Criteria) this;
        }

        public Criteria andDowntimeIsNull() {
            addCriterion("DOWNTIME_ is null");
            return (Criteria) this;
        }

        public Criteria andDowntimeIsNotNull() {
            addCriterion("DOWNTIME_ is not null");
            return (Criteria) this;
        }

        public Criteria andDowntimeEqualTo(BigDecimal value) {
            addCriterion("DOWNTIME_ =", value, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeNotEqualTo(BigDecimal value) {
            addCriterion("DOWNTIME_ <>", value, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeGreaterThan(BigDecimal value) {
            addCriterion("DOWNTIME_ >", value, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DOWNTIME_ >=", value, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeLessThan(BigDecimal value) {
            addCriterion("DOWNTIME_ <", value, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DOWNTIME_ <=", value, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeIn(List<BigDecimal> values) {
            addCriterion("DOWNTIME_ in", values, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeNotIn(List<BigDecimal> values) {
            addCriterion("DOWNTIME_ not in", values, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DOWNTIME_ between", value1, value2, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DOWNTIME_ not between", value1, value2, "downtime");
            return (Criteria) this;
        }

        public Criteria andAttris6IsNull() {
            addCriterion("ATTRIS6_ is null");
            return (Criteria) this;
        }

        public Criteria andAttris6IsNotNull() {
            addCriterion("ATTRIS6_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttris6EqualTo(String value) {
            addCriterion("ATTRIS6_ =", value, "attris6");
            return (Criteria) this;
        }

        public Criteria andAttris6NotEqualTo(String value) {
            addCriterion("ATTRIS6_ <>", value, "attris6");
            return (Criteria) this;
        }

        public Criteria andAttris6GreaterThan(String value) {
            addCriterion("ATTRIS6_ >", value, "attris6");
            return (Criteria) this;
        }

        public Criteria andAttris6GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRIS6_ >=", value, "attris6");
            return (Criteria) this;
        }

        public Criteria andAttris6LessThan(String value) {
            addCriterion("ATTRIS6_ <", value, "attris6");
            return (Criteria) this;
        }

        public Criteria andAttris6LessThanOrEqualTo(String value) {
            addCriterion("ATTRIS6_ <=", value, "attris6");
            return (Criteria) this;
        }

        public Criteria andAttris6Like(String value) {
            addCriterion("ATTRIS6_ like", value, "attris6");
            return (Criteria) this;
        }

        public Criteria andAttris6NotLike(String value) {
            addCriterion("ATTRIS6_ not like", value, "attris6");
            return (Criteria) this;
        }

        public Criteria andAttris6In(List<String> values) {
            addCriterion("ATTRIS6_ in", values, "attris6");
            return (Criteria) this;
        }

        public Criteria andAttris6NotIn(List<String> values) {
            addCriterion("ATTRIS6_ not in", values, "attris6");
            return (Criteria) this;
        }

        public Criteria andAttris6Between(String value1, String value2) {
            addCriterion("ATTRIS6_ between", value1, value2, "attris6");
            return (Criteria) this;
        }

        public Criteria andAttris6NotBetween(String value1, String value2) {
            addCriterion("ATTRIS6_ not between", value1, value2, "attris6");
            return (Criteria) this;
        }

        public Criteria andAttris7IsNull() {
            addCriterion("ATTRIS7_ is null");
            return (Criteria) this;
        }

        public Criteria andAttris7IsNotNull() {
            addCriterion("ATTRIS7_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttris7EqualTo(String value) {
            addCriterion("ATTRIS7_ =", value, "attris7");
            return (Criteria) this;
        }

        public Criteria andAttris7NotEqualTo(String value) {
            addCriterion("ATTRIS7_ <>", value, "attris7");
            return (Criteria) this;
        }

        public Criteria andAttris7GreaterThan(String value) {
            addCriterion("ATTRIS7_ >", value, "attris7");
            return (Criteria) this;
        }

        public Criteria andAttris7GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRIS7_ >=", value, "attris7");
            return (Criteria) this;
        }

        public Criteria andAttris7LessThan(String value) {
            addCriterion("ATTRIS7_ <", value, "attris7");
            return (Criteria) this;
        }

        public Criteria andAttris7LessThanOrEqualTo(String value) {
            addCriterion("ATTRIS7_ <=", value, "attris7");
            return (Criteria) this;
        }

        public Criteria andAttris7Like(String value) {
            addCriterion("ATTRIS7_ like", value, "attris7");
            return (Criteria) this;
        }

        public Criteria andAttris7NotLike(String value) {
            addCriterion("ATTRIS7_ not like", value, "attris7");
            return (Criteria) this;
        }

        public Criteria andAttris7In(List<String> values) {
            addCriterion("ATTRIS7_ in", values, "attris7");
            return (Criteria) this;
        }

        public Criteria andAttris7NotIn(List<String> values) {
            addCriterion("ATTRIS7_ not in", values, "attris7");
            return (Criteria) this;
        }

        public Criteria andAttris7Between(String value1, String value2) {
            addCriterion("ATTRIS7_ between", value1, value2, "attris7");
            return (Criteria) this;
        }

        public Criteria andAttris7NotBetween(String value1, String value2) {
            addCriterion("ATTRIS7_ not between", value1, value2, "attris7");
            return (Criteria) this;
        }

        public Criteria andAttris8IsNull() {
            addCriterion("ATTRIS8_ is null");
            return (Criteria) this;
        }

        public Criteria andAttris8IsNotNull() {
            addCriterion("ATTRIS8_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttris8EqualTo(String value) {
            addCriterion("ATTRIS8_ =", value, "attris8");
            return (Criteria) this;
        }

        public Criteria andAttris8NotEqualTo(String value) {
            addCriterion("ATTRIS8_ <>", value, "attris8");
            return (Criteria) this;
        }

        public Criteria andAttris8GreaterThan(String value) {
            addCriterion("ATTRIS8_ >", value, "attris8");
            return (Criteria) this;
        }

        public Criteria andAttris8GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRIS8_ >=", value, "attris8");
            return (Criteria) this;
        }

        public Criteria andAttris8LessThan(String value) {
            addCriterion("ATTRIS8_ <", value, "attris8");
            return (Criteria) this;
        }

        public Criteria andAttris8LessThanOrEqualTo(String value) {
            addCriterion("ATTRIS8_ <=", value, "attris8");
            return (Criteria) this;
        }

        public Criteria andAttris8Like(String value) {
            addCriterion("ATTRIS8_ like", value, "attris8");
            return (Criteria) this;
        }

        public Criteria andAttris8NotLike(String value) {
            addCriterion("ATTRIS8_ not like", value, "attris8");
            return (Criteria) this;
        }

        public Criteria andAttris8In(List<String> values) {
            addCriterion("ATTRIS8_ in", values, "attris8");
            return (Criteria) this;
        }

        public Criteria andAttris8NotIn(List<String> values) {
            addCriterion("ATTRIS8_ not in", values, "attris8");
            return (Criteria) this;
        }

        public Criteria andAttris8Between(String value1, String value2) {
            addCriterion("ATTRIS8_ between", value1, value2, "attris8");
            return (Criteria) this;
        }

        public Criteria andAttris8NotBetween(String value1, String value2) {
            addCriterion("ATTRIS8_ not between", value1, value2, "attris8");
            return (Criteria) this;
        }

        public Criteria andAttris9IsNull() {
            addCriterion("ATTRIS9_ is null");
            return (Criteria) this;
        }

        public Criteria andAttris9IsNotNull() {
            addCriterion("ATTRIS9_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttris9EqualTo(String value) {
            addCriterion("ATTRIS9_ =", value, "attris9");
            return (Criteria) this;
        }

        public Criteria andAttris9NotEqualTo(String value) {
            addCriterion("ATTRIS9_ <>", value, "attris9");
            return (Criteria) this;
        }

        public Criteria andAttris9GreaterThan(String value) {
            addCriterion("ATTRIS9_ >", value, "attris9");
            return (Criteria) this;
        }

        public Criteria andAttris9GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRIS9_ >=", value, "attris9");
            return (Criteria) this;
        }

        public Criteria andAttris9LessThan(String value) {
            addCriterion("ATTRIS9_ <", value, "attris9");
            return (Criteria) this;
        }

        public Criteria andAttris9LessThanOrEqualTo(String value) {
            addCriterion("ATTRIS9_ <=", value, "attris9");
            return (Criteria) this;
        }

        public Criteria andAttris9Like(String value) {
            addCriterion("ATTRIS9_ like", value, "attris9");
            return (Criteria) this;
        }

        public Criteria andAttris9NotLike(String value) {
            addCriterion("ATTRIS9_ not like", value, "attris9");
            return (Criteria) this;
        }

        public Criteria andAttris9In(List<String> values) {
            addCriterion("ATTRIS9_ in", values, "attris9");
            return (Criteria) this;
        }

        public Criteria andAttris9NotIn(List<String> values) {
            addCriterion("ATTRIS9_ not in", values, "attris9");
            return (Criteria) this;
        }

        public Criteria andAttris9Between(String value1, String value2) {
            addCriterion("ATTRIS9_ between", value1, value2, "attris9");
            return (Criteria) this;
        }

        public Criteria andAttris9NotBetween(String value1, String value2) {
            addCriterion("ATTRIS9_ not between", value1, value2, "attris9");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("ADDRESS_ is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("ADDRESS_ is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("ADDRESS_ =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("ADDRESS_ <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("ADDRESS_ >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("ADDRESS_ >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("ADDRESS_ <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("ADDRESS_ <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("ADDRESS_ like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("ADDRESS_ not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("ADDRESS_ in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("ADDRESS_ not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("ADDRESS_ between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("ADDRESS_ not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddresscodeIsNull() {
            addCriterion("ADDRESSCODE_ is null");
            return (Criteria) this;
        }

        public Criteria andAddresscodeIsNotNull() {
            addCriterion("ADDRESSCODE_ is not null");
            return (Criteria) this;
        }

        public Criteria andAddresscodeEqualTo(String value) {
            addCriterion("ADDRESSCODE_ =", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeNotEqualTo(String value) {
            addCriterion("ADDRESSCODE_ <>", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeGreaterThan(String value) {
            addCriterion("ADDRESSCODE_ >", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeGreaterThanOrEqualTo(String value) {
            addCriterion("ADDRESSCODE_ >=", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeLessThan(String value) {
            addCriterion("ADDRESSCODE_ <", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeLessThanOrEqualTo(String value) {
            addCriterion("ADDRESSCODE_ <=", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeLike(String value) {
            addCriterion("ADDRESSCODE_ like", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeNotLike(String value) {
            addCriterion("ADDRESSCODE_ not like", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeIn(List<String> values) {
            addCriterion("ADDRESSCODE_ in", values, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeNotIn(List<String> values) {
            addCriterion("ADDRESSCODE_ not in", values, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeBetween(String value1, String value2) {
            addCriterion("ADDRESSCODE_ between", value1, value2, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeNotBetween(String value1, String value2) {
            addCriterion("ADDRESSCODE_ not between", value1, value2, "addresscode");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameIsNull() {
            addCriterion("DEALERCOMPANYNAME_ is null");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameIsNotNull() {
            addCriterion("DEALERCOMPANYNAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameEqualTo(String value) {
            addCriterion("DEALERCOMPANYNAME_ =", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameNotEqualTo(String value) {
            addCriterion("DEALERCOMPANYNAME_ <>", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameGreaterThan(String value) {
            addCriterion("DEALERCOMPANYNAME_ >", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameGreaterThanOrEqualTo(String value) {
            addCriterion("DEALERCOMPANYNAME_ >=", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameLessThan(String value) {
            addCriterion("DEALERCOMPANYNAME_ <", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameLessThanOrEqualTo(String value) {
            addCriterion("DEALERCOMPANYNAME_ <=", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameLike(String value) {
            addCriterion("DEALERCOMPANYNAME_ like", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameNotLike(String value) {
            addCriterion("DEALERCOMPANYNAME_ not like", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameIn(List<String> values) {
            addCriterion("DEALERCOMPANYNAME_ in", values, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameNotIn(List<String> values) {
            addCriterion("DEALERCOMPANYNAME_ not in", values, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameBetween(String value1, String value2) {
            addCriterion("DEALERCOMPANYNAME_ between", value1, value2, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameNotBetween(String value1, String value2) {
            addCriterion("DEALERCOMPANYNAME_ not between", value1, value2, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andElecommerce1IsNull() {
            addCriterion("ELECOMMERCE1_ is null");
            return (Criteria) this;
        }

        public Criteria andElecommerce1IsNotNull() {
            addCriterion("ELECOMMERCE1_ is not null");
            return (Criteria) this;
        }

        public Criteria andElecommerce1EqualTo(String value) {
            addCriterion("ELECOMMERCE1_ =", value, "elecommerce1");
            return (Criteria) this;
        }

        public Criteria andElecommerce1NotEqualTo(String value) {
            addCriterion("ELECOMMERCE1_ <>", value, "elecommerce1");
            return (Criteria) this;
        }

        public Criteria andElecommerce1GreaterThan(String value) {
            addCriterion("ELECOMMERCE1_ >", value, "elecommerce1");
            return (Criteria) this;
        }

        public Criteria andElecommerce1GreaterThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCE1_ >=", value, "elecommerce1");
            return (Criteria) this;
        }

        public Criteria andElecommerce1LessThan(String value) {
            addCriterion("ELECOMMERCE1_ <", value, "elecommerce1");
            return (Criteria) this;
        }

        public Criteria andElecommerce1LessThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCE1_ <=", value, "elecommerce1");
            return (Criteria) this;
        }

        public Criteria andElecommerce1Like(String value) {
            addCriterion("ELECOMMERCE1_ like", value, "elecommerce1");
            return (Criteria) this;
        }

        public Criteria andElecommerce1NotLike(String value) {
            addCriterion("ELECOMMERCE1_ not like", value, "elecommerce1");
            return (Criteria) this;
        }

        public Criteria andElecommerce1In(List<String> values) {
            addCriterion("ELECOMMERCE1_ in", values, "elecommerce1");
            return (Criteria) this;
        }

        public Criteria andElecommerce1NotIn(List<String> values) {
            addCriterion("ELECOMMERCE1_ not in", values, "elecommerce1");
            return (Criteria) this;
        }

        public Criteria andElecommerce1Between(String value1, String value2) {
            addCriterion("ELECOMMERCE1_ between", value1, value2, "elecommerce1");
            return (Criteria) this;
        }

        public Criteria andElecommerce1NotBetween(String value1, String value2) {
            addCriterion("ELECOMMERCE1_ not between", value1, value2, "elecommerce1");
            return (Criteria) this;
        }

        public Criteria andElecommerce2IsNull() {
            addCriterion("ELECOMMERCE2_ is null");
            return (Criteria) this;
        }

        public Criteria andElecommerce2IsNotNull() {
            addCriterion("ELECOMMERCE2_ is not null");
            return (Criteria) this;
        }

        public Criteria andElecommerce2EqualTo(String value) {
            addCriterion("ELECOMMERCE2_ =", value, "elecommerce2");
            return (Criteria) this;
        }

        public Criteria andElecommerce2NotEqualTo(String value) {
            addCriterion("ELECOMMERCE2_ <>", value, "elecommerce2");
            return (Criteria) this;
        }

        public Criteria andElecommerce2GreaterThan(String value) {
            addCriterion("ELECOMMERCE2_ >", value, "elecommerce2");
            return (Criteria) this;
        }

        public Criteria andElecommerce2GreaterThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCE2_ >=", value, "elecommerce2");
            return (Criteria) this;
        }

        public Criteria andElecommerce2LessThan(String value) {
            addCriterion("ELECOMMERCE2_ <", value, "elecommerce2");
            return (Criteria) this;
        }

        public Criteria andElecommerce2LessThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCE2_ <=", value, "elecommerce2");
            return (Criteria) this;
        }

        public Criteria andElecommerce2Like(String value) {
            addCriterion("ELECOMMERCE2_ like", value, "elecommerce2");
            return (Criteria) this;
        }

        public Criteria andElecommerce2NotLike(String value) {
            addCriterion("ELECOMMERCE2_ not like", value, "elecommerce2");
            return (Criteria) this;
        }

        public Criteria andElecommerce2In(List<String> values) {
            addCriterion("ELECOMMERCE2_ in", values, "elecommerce2");
            return (Criteria) this;
        }

        public Criteria andElecommerce2NotIn(List<String> values) {
            addCriterion("ELECOMMERCE2_ not in", values, "elecommerce2");
            return (Criteria) this;
        }

        public Criteria andElecommerce2Between(String value1, String value2) {
            addCriterion("ELECOMMERCE2_ between", value1, value2, "elecommerce2");
            return (Criteria) this;
        }

        public Criteria andElecommerce2NotBetween(String value1, String value2) {
            addCriterion("ELECOMMERCE2_ not between", value1, value2, "elecommerce2");
            return (Criteria) this;
        }

        public Criteria andElecommerce3IsNull() {
            addCriterion("ELECOMMERCE3_ is null");
            return (Criteria) this;
        }

        public Criteria andElecommerce3IsNotNull() {
            addCriterion("ELECOMMERCE3_ is not null");
            return (Criteria) this;
        }

        public Criteria andElecommerce3EqualTo(String value) {
            addCriterion("ELECOMMERCE3_ =", value, "elecommerce3");
            return (Criteria) this;
        }

        public Criteria andElecommerce3NotEqualTo(String value) {
            addCriterion("ELECOMMERCE3_ <>", value, "elecommerce3");
            return (Criteria) this;
        }

        public Criteria andElecommerce3GreaterThan(String value) {
            addCriterion("ELECOMMERCE3_ >", value, "elecommerce3");
            return (Criteria) this;
        }

        public Criteria andElecommerce3GreaterThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCE3_ >=", value, "elecommerce3");
            return (Criteria) this;
        }

        public Criteria andElecommerce3LessThan(String value) {
            addCriterion("ELECOMMERCE3_ <", value, "elecommerce3");
            return (Criteria) this;
        }

        public Criteria andElecommerce3LessThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCE3_ <=", value, "elecommerce3");
            return (Criteria) this;
        }

        public Criteria andElecommerce3Like(String value) {
            addCriterion("ELECOMMERCE3_ like", value, "elecommerce3");
            return (Criteria) this;
        }

        public Criteria andElecommerce3NotLike(String value) {
            addCriterion("ELECOMMERCE3_ not like", value, "elecommerce3");
            return (Criteria) this;
        }

        public Criteria andElecommerce3In(List<String> values) {
            addCriterion("ELECOMMERCE3_ in", values, "elecommerce3");
            return (Criteria) this;
        }

        public Criteria andElecommerce3NotIn(List<String> values) {
            addCriterion("ELECOMMERCE3_ not in", values, "elecommerce3");
            return (Criteria) this;
        }

        public Criteria andElecommerce3Between(String value1, String value2) {
            addCriterion("ELECOMMERCE3_ between", value1, value2, "elecommerce3");
            return (Criteria) this;
        }

        public Criteria andElecommerce3NotBetween(String value1, String value2) {
            addCriterion("ELECOMMERCE3_ not between", value1, value2, "elecommerce3");
            return (Criteria) this;
        }

        public Criteria andElecommerce4IsNull() {
            addCriterion("ELECOMMERCE4_ is null");
            return (Criteria) this;
        }

        public Criteria andElecommerce4IsNotNull() {
            addCriterion("ELECOMMERCE4_ is not null");
            return (Criteria) this;
        }

        public Criteria andElecommerce4EqualTo(String value) {
            addCriterion("ELECOMMERCE4_ =", value, "elecommerce4");
            return (Criteria) this;
        }

        public Criteria andElecommerce4NotEqualTo(String value) {
            addCriterion("ELECOMMERCE4_ <>", value, "elecommerce4");
            return (Criteria) this;
        }

        public Criteria andElecommerce4GreaterThan(String value) {
            addCriterion("ELECOMMERCE4_ >", value, "elecommerce4");
            return (Criteria) this;
        }

        public Criteria andElecommerce4GreaterThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCE4_ >=", value, "elecommerce4");
            return (Criteria) this;
        }

        public Criteria andElecommerce4LessThan(String value) {
            addCriterion("ELECOMMERCE4_ <", value, "elecommerce4");
            return (Criteria) this;
        }

        public Criteria andElecommerce4LessThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCE4_ <=", value, "elecommerce4");
            return (Criteria) this;
        }

        public Criteria andElecommerce4Like(String value) {
            addCriterion("ELECOMMERCE4_ like", value, "elecommerce4");
            return (Criteria) this;
        }

        public Criteria andElecommerce4NotLike(String value) {
            addCriterion("ELECOMMERCE4_ not like", value, "elecommerce4");
            return (Criteria) this;
        }

        public Criteria andElecommerce4In(List<String> values) {
            addCriterion("ELECOMMERCE4_ in", values, "elecommerce4");
            return (Criteria) this;
        }

        public Criteria andElecommerce4NotIn(List<String> values) {
            addCriterion("ELECOMMERCE4_ not in", values, "elecommerce4");
            return (Criteria) this;
        }

        public Criteria andElecommerce4Between(String value1, String value2) {
            addCriterion("ELECOMMERCE4_ between", value1, value2, "elecommerce4");
            return (Criteria) this;
        }

        public Criteria andElecommerce4NotBetween(String value1, String value2) {
            addCriterion("ELECOMMERCE4_ not between", value1, value2, "elecommerce4");
            return (Criteria) this;
        }

        public Criteria andElecommercename1IsNull() {
            addCriterion("ELECOMMERCENAME1_ is null");
            return (Criteria) this;
        }

        public Criteria andElecommercename1IsNotNull() {
            addCriterion("ELECOMMERCENAME1_ is not null");
            return (Criteria) this;
        }

        public Criteria andElecommercename1EqualTo(String value) {
            addCriterion("ELECOMMERCENAME1_ =", value, "elecommercename1");
            return (Criteria) this;
        }

        public Criteria andElecommercename1NotEqualTo(String value) {
            addCriterion("ELECOMMERCENAME1_ <>", value, "elecommercename1");
            return (Criteria) this;
        }

        public Criteria andElecommercename1GreaterThan(String value) {
            addCriterion("ELECOMMERCENAME1_ >", value, "elecommercename1");
            return (Criteria) this;
        }

        public Criteria andElecommercename1GreaterThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCENAME1_ >=", value, "elecommercename1");
            return (Criteria) this;
        }

        public Criteria andElecommercename1LessThan(String value) {
            addCriterion("ELECOMMERCENAME1_ <", value, "elecommercename1");
            return (Criteria) this;
        }

        public Criteria andElecommercename1LessThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCENAME1_ <=", value, "elecommercename1");
            return (Criteria) this;
        }

        public Criteria andElecommercename1Like(String value) {
            addCriterion("ELECOMMERCENAME1_ like", value, "elecommercename1");
            return (Criteria) this;
        }

        public Criteria andElecommercename1NotLike(String value) {
            addCriterion("ELECOMMERCENAME1_ not like", value, "elecommercename1");
            return (Criteria) this;
        }

        public Criteria andElecommercename1In(List<String> values) {
            addCriterion("ELECOMMERCENAME1_ in", values, "elecommercename1");
            return (Criteria) this;
        }

        public Criteria andElecommercename1NotIn(List<String> values) {
            addCriterion("ELECOMMERCENAME1_ not in", values, "elecommercename1");
            return (Criteria) this;
        }

        public Criteria andElecommercename1Between(String value1, String value2) {
            addCriterion("ELECOMMERCENAME1_ between", value1, value2, "elecommercename1");
            return (Criteria) this;
        }

        public Criteria andElecommercename1NotBetween(String value1, String value2) {
            addCriterion("ELECOMMERCENAME1_ not between", value1, value2, "elecommercename1");
            return (Criteria) this;
        }

        public Criteria andElecommercename2IsNull() {
            addCriterion("ELECOMMERCENAME2_ is null");
            return (Criteria) this;
        }

        public Criteria andElecommercename2IsNotNull() {
            addCriterion("ELECOMMERCENAME2_ is not null");
            return (Criteria) this;
        }

        public Criteria andElecommercename2EqualTo(String value) {
            addCriterion("ELECOMMERCENAME2_ =", value, "elecommercename2");
            return (Criteria) this;
        }

        public Criteria andElecommercename2NotEqualTo(String value) {
            addCriterion("ELECOMMERCENAME2_ <>", value, "elecommercename2");
            return (Criteria) this;
        }

        public Criteria andElecommercename2GreaterThan(String value) {
            addCriterion("ELECOMMERCENAME2_ >", value, "elecommercename2");
            return (Criteria) this;
        }

        public Criteria andElecommercename2GreaterThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCENAME2_ >=", value, "elecommercename2");
            return (Criteria) this;
        }

        public Criteria andElecommercename2LessThan(String value) {
            addCriterion("ELECOMMERCENAME2_ <", value, "elecommercename2");
            return (Criteria) this;
        }

        public Criteria andElecommercename2LessThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCENAME2_ <=", value, "elecommercename2");
            return (Criteria) this;
        }

        public Criteria andElecommercename2Like(String value) {
            addCriterion("ELECOMMERCENAME2_ like", value, "elecommercename2");
            return (Criteria) this;
        }

        public Criteria andElecommercename2NotLike(String value) {
            addCriterion("ELECOMMERCENAME2_ not like", value, "elecommercename2");
            return (Criteria) this;
        }

        public Criteria andElecommercename2In(List<String> values) {
            addCriterion("ELECOMMERCENAME2_ in", values, "elecommercename2");
            return (Criteria) this;
        }

        public Criteria andElecommercename2NotIn(List<String> values) {
            addCriterion("ELECOMMERCENAME2_ not in", values, "elecommercename2");
            return (Criteria) this;
        }

        public Criteria andElecommercename2Between(String value1, String value2) {
            addCriterion("ELECOMMERCENAME2_ between", value1, value2, "elecommercename2");
            return (Criteria) this;
        }

        public Criteria andElecommercename2NotBetween(String value1, String value2) {
            addCriterion("ELECOMMERCENAME2_ not between", value1, value2, "elecommercename2");
            return (Criteria) this;
        }

        public Criteria andElecommercename3IsNull() {
            addCriterion("ELECOMMERCENAME3_ is null");
            return (Criteria) this;
        }

        public Criteria andElecommercename3IsNotNull() {
            addCriterion("ELECOMMERCENAME3_ is not null");
            return (Criteria) this;
        }

        public Criteria andElecommercename3EqualTo(String value) {
            addCriterion("ELECOMMERCENAME3_ =", value, "elecommercename3");
            return (Criteria) this;
        }

        public Criteria andElecommercename3NotEqualTo(String value) {
            addCriterion("ELECOMMERCENAME3_ <>", value, "elecommercename3");
            return (Criteria) this;
        }

        public Criteria andElecommercename3GreaterThan(String value) {
            addCriterion("ELECOMMERCENAME3_ >", value, "elecommercename3");
            return (Criteria) this;
        }

        public Criteria andElecommercename3GreaterThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCENAME3_ >=", value, "elecommercename3");
            return (Criteria) this;
        }

        public Criteria andElecommercename3LessThan(String value) {
            addCriterion("ELECOMMERCENAME3_ <", value, "elecommercename3");
            return (Criteria) this;
        }

        public Criteria andElecommercename3LessThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCENAME3_ <=", value, "elecommercename3");
            return (Criteria) this;
        }

        public Criteria andElecommercename3Like(String value) {
            addCriterion("ELECOMMERCENAME3_ like", value, "elecommercename3");
            return (Criteria) this;
        }

        public Criteria andElecommercename3NotLike(String value) {
            addCriterion("ELECOMMERCENAME3_ not like", value, "elecommercename3");
            return (Criteria) this;
        }

        public Criteria andElecommercename3In(List<String> values) {
            addCriterion("ELECOMMERCENAME3_ in", values, "elecommercename3");
            return (Criteria) this;
        }

        public Criteria andElecommercename3NotIn(List<String> values) {
            addCriterion("ELECOMMERCENAME3_ not in", values, "elecommercename3");
            return (Criteria) this;
        }

        public Criteria andElecommercename3Between(String value1, String value2) {
            addCriterion("ELECOMMERCENAME3_ between", value1, value2, "elecommercename3");
            return (Criteria) this;
        }

        public Criteria andElecommercename3NotBetween(String value1, String value2) {
            addCriterion("ELECOMMERCENAME3_ not between", value1, value2, "elecommercename3");
            return (Criteria) this;
        }

        public Criteria andElecommercename4IsNull() {
            addCriterion("ELECOMMERCENAME4_ is null");
            return (Criteria) this;
        }

        public Criteria andElecommercename4IsNotNull() {
            addCriterion("ELECOMMERCENAME4_ is not null");
            return (Criteria) this;
        }

        public Criteria andElecommercename4EqualTo(String value) {
            addCriterion("ELECOMMERCENAME4_ =", value, "elecommercename4");
            return (Criteria) this;
        }

        public Criteria andElecommercename4NotEqualTo(String value) {
            addCriterion("ELECOMMERCENAME4_ <>", value, "elecommercename4");
            return (Criteria) this;
        }

        public Criteria andElecommercename4GreaterThan(String value) {
            addCriterion("ELECOMMERCENAME4_ >", value, "elecommercename4");
            return (Criteria) this;
        }

        public Criteria andElecommercename4GreaterThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCENAME4_ >=", value, "elecommercename4");
            return (Criteria) this;
        }

        public Criteria andElecommercename4LessThan(String value) {
            addCriterion("ELECOMMERCENAME4_ <", value, "elecommercename4");
            return (Criteria) this;
        }

        public Criteria andElecommercename4LessThanOrEqualTo(String value) {
            addCriterion("ELECOMMERCENAME4_ <=", value, "elecommercename4");
            return (Criteria) this;
        }

        public Criteria andElecommercename4Like(String value) {
            addCriterion("ELECOMMERCENAME4_ like", value, "elecommercename4");
            return (Criteria) this;
        }

        public Criteria andElecommercename4NotLike(String value) {
            addCriterion("ELECOMMERCENAME4_ not like", value, "elecommercename4");
            return (Criteria) this;
        }

        public Criteria andElecommercename4In(List<String> values) {
            addCriterion("ELECOMMERCENAME4_ in", values, "elecommercename4");
            return (Criteria) this;
        }

        public Criteria andElecommercename4NotIn(List<String> values) {
            addCriterion("ELECOMMERCENAME4_ not in", values, "elecommercename4");
            return (Criteria) this;
        }

        public Criteria andElecommercename4Between(String value1, String value2) {
            addCriterion("ELECOMMERCENAME4_ between", value1, value2, "elecommercename4");
            return (Criteria) this;
        }

        public Criteria andElecommercename4NotBetween(String value1, String value2) {
            addCriterion("ELECOMMERCENAME4_ not between", value1, value2, "elecommercename4");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}